<?php
class Model_DbTable_ProductSize extends Apps_Db_Table_Abstract {
	protected $_name = 'product_size';

	const STATUS_ACTIVE   = 1;
	const STATUS_INACTIVE = 0;
	const STATUS_DELETED  = -1;

	const SHOW_HOME       = 1;
	const NOT_SHOW_HOME   = 0;


	//LIST
// 	public function getList () {
// 		$q = $this->_db
// 				  ->select()
// 				  ->from($this->_name, null)
// 				  ->where('status =?', self::STATUS_ACTIVE)
// 				  ->order($this->_name . '.title')
// 				  ->columns(array('id'			    => 'id',
// 				 				  'title'		    => 'title',
// 				 				  'sorting_number'	=> 'sorting_number',
// 				  				  'created_date'    => 'created_date'));
//  		return $q;
// 	}


	public function listByProductSizeJson($productSizeJson) {
	    $sizeArray = Zend_Json::decode($productSizeJson);

	    $size = array();
	    if($sizeArray) {
	        foreach($sizeArray as $sizeId) {
	            $r = $this->_db
            	            ->select()
            	            ->from($this->_name, null)
            	            ->where('status =?', self::STATUS_ACTIVE)
            	            ->where('id =?', $sizeId)
            	            ->columns(array('title' => 'title'))
            	            ->query()
            	            ->fetch();
	            if($r) {
	                array_push($size, $r['title']);
	            }
	        }
	    }

	    return $size;
	}

}